<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Creating a threshold for a metric based on a metric: Basic thresholds</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
h3.whs2 { margin-left:24px; }
p.whs3 { color:#000000; }
img_whs4 { border:none; width:126px; height:27px; float:none; border-style:none; }
img_whs5 { border:none; width:13px; height:19px; float:none; border-style:none; }
p.whs6 { margin-left:0px; }
ul.whs7 { list-style:decimal; }
ul.whs8 { list-style:disc; }
p.whs9 { margin-left:40px; }
h2.whs10 { font-size:9pt; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs6 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nAdding features for users\nHighlighting specific sets of data: Thresholds\nCreating a threshold for a metric based on a metric: Visual thresholds");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Creating a threshold for a metric based on a metric: Visual thresholds</h1>
<p>Visual thresholds are thresholds defined for a metric, which are based 
 on that same metric or on another metric. Visual thresholds use range 
 expressions (such as greater than, less than, between, top, bottom). Visual 
 thresholds consist of one expression, for example, a visual threshold 
 can calculate revenue that is greater than $10,000 and apply special formatting 
 to the values that match the condition or can replace the values with 
 images or symbols. </p>
<p>To define a threshold that uses more complex expressions, and is applied 
 to multiple metrics, see 
<a HREF="Create_advanced_threshold.htm">Creating 
 a threshold for multiple metrics: Complex thresholds</a>.</p>
<p>You can define your own visual thresholds with custom formatting for 
 a report. For example, if you want all revenue values over $50,000 formatted 
 with red, Arial font, you can define a threshold for that range of values 
 and with that formatting. On the same report, you can have all revenue 
 values below $10,000 be replaced by an image of an arrow pointing down. 
 The procedure below describes how to define and format a visual threshold.</p>
<p>For prerequisites, see 
<a href="Thresholds.htm">About thresholds</a>. 
 </p>
<h2>To define and format a visual threshold</h2>
<ol type="1" class="whs1">
	
<li class=p><p>Run a report.</p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Data</B></span> 
 menu, select <span style="font-weight: bold;"><B>Visual Threshold Editor</B></span>. 
 The Visual Threshold Editor opens. </p></li>
</ol>
<h3 class="whs2">Specify the threshold's conditions</h3>
<ol start="3" type="1" class="whs1">
	
<li style=" color: #000000; " class=p><p class="whs3">In 
 the <span style="font-weight: bold;"><B>Thresholds for</B></span> drop-down list, 
 select the metric for which to create the threshold. The list includes 
 all the metrics defined for the report. </p></li>
	
<li style=" color: #000000; " class=p><p class="whs3">In 
 the <span style="font-weight: bold;"><B>Properties</B></span> area, from the 
 <span style="font-weight: bold;"><B>Type</B></span> drop-down list, select the 
 type of condition to use for the threshold. For example, if you want to 
 define Daily Revenue greater than $40,000, select <span style="font-weight: bold;"><B>Value</B></span> 
 from the drop-down list. This ensures that the threshold is based on an 
 actual value, in this case, $40,000. If you want to define a threshold 
 for the Top 5% of Daily Revenue, select <span style="font-weight: bold;"><B>Highest 
 %</B></span><span>.</span></p></li>
</ol>
<ol start="5" type="1" class="whs1">
	
<li style=" color: #000000; " class=p><p class="whs3">From 
 the <span style="font-weight: bold;"><B>Based on</B></span> drop-down list, select 
 whether the threshold condition is based on the metric <span style="font-weight: bold;"><B>Itself</B></span> 
 or on another metric on the report.</p></li>
	
<li style=" color: #000000; " class=p><p class="whs3">Click 
 the <span style="font-weight: bold;"><B>Close</B></span> icon to close the Qualification 
 pane.</p></li>
	
<li style=" color: #000000; " class=p><p class="whs3">Use 
 the threshold bar to define a value and to format your new threshold(s), 
 as shown below. Each slider on the bar represents a different threshold 
 value. <span style="margin-left: 80px;"><br>

	<br>

	<img src="images/thresholdslidermenu.gif" x-maintain-ratio="TRUE" width="126px" height="27px" border="0" class="img_whs4"></span></p></li>
	
<li style=" color: #000000; " class=p><p class="whs3"><span 
 style="margin-left: 0px;">To add a new threshold value, click the </span><span 
 style="margin-left: 0px; font-weight: bold;"><B>Add Threshold</B></span><span 
 style="margin-left: 0px;"> <img src="images/thresholdslider.gif" x-maintain-ratio="TRUE" width="13px" height="19px" border="0" class="img_whs5">icon, as shown in the image above. A slider 
 is added to the threshold bar. The slider's initial location differs depending 
 on the type of condition you specified above. You can click on the slider 
 and add a new value in the </span><span style="margin-left: 0px; font-weight: bold;"><B>Enter 
 Value</B></span><span style="margin-left: 0px;"> field, or you can move the 
 slider to a new value.</span></p></li>
</ol>
<ol start="9" type="1" class="whs1">
	
<li class=p><p>Add and shift additional sliders as necessary. For example, 
 if you want a threshold to display green font for all values above 1 million, 
 and red font for all values below 20,000, you must have two sliders on 
 the threshold bar, one representing data greater than 1 million and another 
 representing data less than 20,000. </p></li>
	
<li class=p><p>To delete all of the sliders from the bar, click <span 
 style="font-weight: bold;"><B>Remove </B></span>at the top of the Visual Threshold 
 Editor. </p></li>
</ol>
<h3 class="whs2">Specify the formatting for the threshold</h3>
<ol start="12" type="1" class="whs1">
	
<li class=p><p class="whs6">Do one of the following:</p></li>
</ol>
<ul start="13" type="1" class="whs7">
	<ul type="disc" class="whs8">
		
<li class=p><p>To format a specific threshold condition: Double-click 
 the threshold slider to format. The Format dialog box opens.</p></li>
	</ul>
</ul>
<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs9">To 
 format a threshold range, the area between two sliders: Double-click anywhere 
 in the space between the two sliders that you want to format. The Format 
 dialog box opens. </p></li>
</ul>
<p class="whs9">For steps to format a threshold, see 
<a href="Format_Thresholds_Editor.htm">Format 
 Thresholds Editor</a>.</p>
<ol start="13" type="1" class="whs1">
	
<li class=p><p>You can see a sample of your formatting on the threshold 
 bar. Click <span style="font-weight: bold;"><B>Apply</B></span> to apply your 
 changes, or select <span style="font-weight: bold;"><B>OK</B></span> to apply 
 the changes and close the editor.</p></li>
</ol>
<h2 class="whs10">Related Topics</h2>
<ul><ul type="disc" class="whs8">
		
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Thresholds_on_report.htm">Displaying 
 thresholds on a report</a></p></li>
		
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Thresholds.htm">About 
 thresholds</a></p></li>
		
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Add_predefined_thresholds.htm">Adding 
 a quick threshold to a report</a></p></li>
		
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Create_advanced_threshold.htm">Creating 
 a threshold for multiple metrics: Advanced thresholds</a></p></li>
	</ul>
</ul>
<p>&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
